Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailTransactionDeliveryPreferenceID (PK) | A unique system allocated identifier for the record of the Customer's preferences for the delivery of the goods purchased in a particular RetailTransaction. | ID_DV_PRFC | Identity | integer | |
DeliverySequenceOrderCode (PK) | Indicates the relative order for the execution of this delivery instruction. | IC_DV_ORD | Code2 | char(2) | |
ShipToName | The name of the party to whom the delivery is made. | NM_SHP_TO | Name | varchar(40) | |
ShipToAddressID (FK) | A unique system allocated identifier for the Address to which the delivery is made. | ID_ADS_SHP_TO | Identity | integer | Address(LO_ADS) |
EmailAddressID (FK) | A unique system assigned identifier for an electronic address for sending messages. | ID_EM_ADS | Identity | integer | EmailAddress(LO_EML_ADS) |
TelephoneID (FK) | A unique system assigned identifier for this Telephone number | ID_PH | Identity | integer | Telephone(LO_PH) |
PreferredServiceLevelCode | A retailer defined code denoting which level of delivery service is to be used when making the delivery. Examples include: Express, Ground, Overnight. | TY_LV_SV_PRFC | Code2 | char(2) | |
PreferredDateTime | The preferred delivery date & time | TS_DV_PRFC | AuditDateTime | datetime | |
RequiredPaymentAmount | How much is required to be paid for COD shipment? | MO_PYM_RQ | MoneyShortRetail | decimal(7,2) | |
PaymentMethodCode | A retailer defined code denoting which payment method was used when paying for a COD shipment. | LU_PYM_MTH | Code2 | char(2) | |
SpecialInstructions | Narrative text, giving special delivery instructions. | NA_INST_SPL | DescriptionNarrative | varchar(4000) | |